Gestor
41T1Ak1Kcqnifu29Y3hlr9USZa7ZV6Ldy1r9zPvYJQ/kVM/NTU17bcNDbcxoAGpOwtb1DcZZQfnqE4SUZD2rRoNejezWQPLI/009eE7wIV7ZMPUJVkqqrcBJTRxNZGpe1Az7L1tpUajtRw==
Gestor
config
nome_fantasia,System.String
cnpj_cpf,System.String
logradouro,System.String
numero,System.String
bairro,System.String
uf,System.String
telefone,System.String
razao_social,System.String
cidade,System.String
ie_rg,System.String
imagem_logo,System.Byte[]
30
False
config
Gestor
select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone,
cidade.nome as cidade, c.ie_rg, c.imagem_logo
from configuracao c
left join cidade on cidade.id = c.cidade_id
dados
id,System.Int32
numero,System.String
aliquota_icms,System.Decimal
ISENTAS,System.Decimal
serie_nfe,System.String
modelo,System.String
data_emissao,System.DateTime
data_ent_sai,System.DateTime
destinatario_nome,System.String
destinatario_uf,System.String
cfop,System.String
valor_total,System.Decimal
base_icms,System.Decimal
valor_icms,System.Decimal
valor_icms_st,System.Decimal
valor_ipi,System.Decimal
valor_pis,System.Decimal
valor_cofins,System.Decimal
OUTRAS,System.Decimal
despesas,System.Decimal
desconto,System.Decimal
id1,System.Int32
numero1,System.String
rateio_despesas,System.Decimal
rateio_icms,System.Decimal
rateio_frete,System.Decimal
rateio_seguro,System.Decimal
rateio_ipi,System.Decimal
rateio_desconto,System.Decimal
frete,System.Decimal
seguro,System.Decimal
ipi,System.Decimal
aliquota_icms1,System.Decimal
valor_icms_st1,System.Decimal
despesas1,System.Decimal
desconto1,System.Decimal
rateio_desonerado,System.Decimal
valor_icms_desonerado,System.Decimal
valor_tot,System.Decimal
30
False
dados
Gestor
select nf.id, nf.numero,
IF(nfi.cfop = '1556' OR nfi.cfop = '2556' OR RIGHT(nfi.cst, 2) = '40' OR RIGHT(nfi.cst, 2) = '60', 0, nfi.aliquota_icms) AS aliquota_icms,
nf.id, nf.numero,
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.despesas/100)) AS rateio_despesas,
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.valor_icms_st/100)) AS rateio_icms,
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.frete/100)) AS rateio_frete,
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.seguro/100)) AS rateio_seguro,
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.valor_ipi/100)) AS rateio_ipi,
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.desconto/100)) AS rateio_desconto,
IF(RIGHT(nfi.cst, 2) = '40', nf.valor_icms_desonerado, 0) as rateio_desonerado,
nf.valor_icms_st,
nf.frete,
nf.seguro,
nf.despesas,
nf.ipi,
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.total_desconto/100)) AS desconto,
SUM(nfi.valor_total) as valor_total,
IF(nfi.cfop = '1556' OR nfi.cfop = '2556' or RIGHT(nfi.cst, 2) = '40' OR RIGHT(nfi.cst, 2) = '60', 0, SUM(nfi.base_icms)) as base_icms,
IF(nfi.cfop = '1556' OR nfi.cfop = '2556' or RIGHT(nfi.cst, 2) = '40' OR RIGHT(nfi.cst, 2) = '60', 0, SUM(nfi.valor_icms)) as valor_icms,
SUM(nfi.valor_icms_st) as valor_icms_st,
IF(RIGHT(nfi.cst, 2) = '40', SUM(nfi.valor_total) - nf.valor_icms_desonerado +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.despesas/100)) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.valor_icms_st/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.frete/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.seguro/100)) +
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.valor_ipi/100)) -
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.total_desconto/100)), 0) as ISENTAS,
IF(RIGHT(nfi.cst, 2) != '40' && aliquota_icms = 0 OR nfi.cfop = '1556' OR nfi.cfop = '2403' OR nfi.cfop = '1403' OR nfi.cfop = '2405' OR nfi.cfop = '1405',
SUM(nfi.valor_total) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.despesas/100)) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.valor_icms_st/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.frete/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.seguro/100)) +
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.valor_ipi/100)) -
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.total_desconto/100)),
IF(nfi.base_icms > 0 && aliquota_icms>0 && RIGHT(nfi.cst, 2) != '40',
SUM(nfi.valor_total) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.despesas/100)) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.valor_icms_st/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.frete/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.seguro/100)) +
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.valor_ipi/100)) -
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.total_desconto/100)) -
SUM(nfi.base_icms),
IF(nfi.base_icms > 0 && aliquota_icms>0 && RIGHT(nfi.cst, 2) = '40', 0,
IF(nfi.base_icms = 0 && aliquota_icms=0 && RIGHT(nfi.cst, 2) = '40', 0, 0)))) as OUTRAS,
IF(RIGHT(nfi.cst, 2) = '40' OR ((RIGHT(nfi.cst, 2) = '90' && (nfi.cfop = '1556' OR nfi.cfop = '2556'))),
SUM(nfi.valor_total) - nf.valor_icms_desonerado +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.despesas/100)) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.valor_icms_st/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.frete/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.seguro/100)) +
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.valor_ipi/100)) -
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.total_desconto/100)),
SUM(nfi.valor_total) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.despesas/100)) +
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.valor_icms_st/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.frete/100))+
SUM((((nfi.valor_total / nf.valor_produtos) * 100) * nf.seguro/100)) +
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.valor_ipi/100)) -
SUM((((nfi.valor_total / nfi.valor_total) * 100) * nfi.total_desconto/100)))
AS valor_tot,
nf.valor_icms_desonerado,
nf.serie_nfe, IF(nf.modelo is null, "55", nf.modelo) as modelo,
nf.data_emissao, nf.data_ent_sai, nf.destinatario_nome, nf.destinatario_uf, nfi.cfop ,
nf.despesas, nf.desconto
from nota_fiscal nf
left join nota_fiscal_item nfi on nfi.nota_fiscal_id = nf.id
where tipo = '0 - Entrada' and
DATE_FORMAT(CAST(data_ent_sai as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND
DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d')
group by nfi.cst, nfi.aliquota_icms, nf.numero, nfi.cfop
order by nf.destinatario_nome
notas
id,System.Int32
numero,System.String
despesas,System.Decimal
desconto,System.Decimal
valor_icms_st,System.Decimal
frete,System.Decimal
seguro,System.Decimal
ipi,System.Decimal
30
False
notas
Gestor
select
nf.id,
nf.numero,
nf.valor_icms_st,
nf.frete,
nf.seguro,
nf.despesas,
nf.ipi,
nf.desconto
from nota_fiscal nf
where tipo = '0 - Entrada' and
DATE_FORMAT(CAST(data_ent_sai as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND
DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d')
,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False
,data_inicial,data_inicial,System.String,,False,False
,data_final,data_final,System.String,,False,False
,produto_id,produto_id,System.String,_x0030_,False,False
,grupo_id,grupo_id,System.String,_x0030_,False,False
,subgrupo_id,subgrupo_id,System.String,_x0030_,False,False
,familia_id,familia_id,System.String,_x0030_,False,False
,descricao_filtros,descricao_filtros,System.String,,False,False
,codigo_relatorio,codigo_relatorio,System.String,,False,False
,agrupar_produtos,agrupar_produtos,System.String,,False,False
,tipo_mercadoria,tipo_mercadoria,System.String,,False,False
,vendedor_id,vendedor_id,System.Int32,_x0030_,False,False
,agrupar_por,agrupar_por,System.String,,False,False
,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0038__x005F_x002F_8_x005F_x002F_2018_x005F_x0020_11:26:13_x005F_x0020_AM_x002C__x005F_x0038__x005F_x002F_8_x005F_x002F_2018_x005F_x0020_11:26:13_x005F_x0020_AM,False,False
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,18.2,27.7,0.8
Transparent
24,0.1,3.6,0.4
Arial,10
Right
0,0,0,0
Text3
{PageNofMThrough}
Black
Transparent
0,0.1,8.4,0.6
Arial,8
0,0,0,0
Text21
Kinyx Gestor v.{versao} - www.kinyx.com.br
Black
Expression
PageFooterBand1
Transparent
0,0.4,27.7,3.8
GlassBrush,Gainsboro,True,0.2
0,2.2,27.6,0.8
Transparent
0.2,0.1,27,0.6
Tahoma,14.25,Bold,Point,False,0
781d2eafa39f4cfd8624172f344d8295
Center
0,0,0,0
Text1
DADOS FISCAIS POR CFOP - ENTRADAS
Black
Expression
300f366621684f32953b76a2d6198877
Panel1
Transparent
2.2,0,13.6,0.4
Tahoma,9.75,Bold,Point,False,0
d087582087324b43b26b933783e54715
0,0,0,0
Text4
{config.razao_social}
Black
Expression
Transparent
2.2,0.4,13.6,1.8
Tahoma,9,Regular,Point,False,0
bb9274ce219d404b9b7c76e7c06192c3
0,0,0,0
Text14
CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg}
End.: {config.logradouro}, {config.numero}
Bairro: {config.bairro}
{config.cidade}/{config.uf}
Black
Expression
Transparent
0,0,2.2,2.2
config.imagem_logo
4c2d6b0c76e04a869266abd979183a20
imgLogo
True
Transparent
0,3,1.4,0.6
Tahoma,8.25,Bold,Point,False,0
a3d652b2a4424de8bdf396547c4df7b7
Right
0,0,0,0
Text44
Período:
Black
Expression
Center
Transparent
22.2,0.2,5.4,0.6
Tahoma,8.25,Bold,Point,False,0
e765e1718f9b42739e82d794b7030864
Right
0,0,0,0
Text2
{Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")}
Black
Expression
Transparent
24.4,0.6,3.2,0.6
Tahoma,8.25,Bold,Point,False,0
f5777b5814fd4ba3ad34e073c29fca76
Right
0,0,0,0
Text20
Rel: {codigo_relatorio}
Black
Expression
Transparent
1.4,3,2.2,0.6
Tahoma,8.25,Bold,Point,False,0
012bc62092f94daa89dce5cd49f62027
Right
0,0,0,0
Text18
{Data.FromDate.Date}
Black
Expression
Center
Transparent
3.6,3,0.4,0.6
Tahoma,8.25,Bold,Point,False,0
34d07445016a491488d9d09460cd21a1
Center
0,0,0,0
Text19
a
Black
Expression
Center
Transparent
4,3,2.2,0.6
Tahoma,8.25,Bold,Point,False,0
6ca9b698cfee43d0b2f8e21b2dee25be
0,0,0,0
Text51
{Data.ToDate.Date}
Black
Expression
Center
ReportTitleBand1
Transparent
0,5,27.7,0.6
Transparent
0,0,1.8,0.6
Tahoma,8.25,Bold,Point,False,0
8d21e504f4c34a259bb5bd3ebe812ef1
0,0,0,0
Text5
Data
Black
Expression
Center
Transparent
1.8,0,2,0.6
Tahoma,8.25,Bold,Point,False,0
1b6698d245dc4281882e1960f95c769f
0,0,0,0
Text6
Núm.
Black
Expression
Center
Transparent
9.6,0,1.2,0.6
Tahoma,8.25,Bold,Point,False,0
1885cf49561e4aabb12f83214133b841
Right
0,0,0,0
Text10
CFOP
Black
Expression
Center
Transparent
5.8,0,3.8,0.6
Tahoma,8.25,Bold,Point,False,0
0ac0cf4b438e42e2a01d80e7b7f4dfdf
0,0,0,0
Text9
Destinatário/Emitente
Black
Expression
Center
Transparent
10.8,0,1,0.6
Tahoma,8.25,Bold,Point,False,0
de97fa4781c146b690ef97da5f48062a
Right
0,0,0,0
Text16
UF
Black
Expression
Center
Transparent
15.6,0,1.6,0.6
Tahoma,8.25,Bold,Point,False,0
0e7ccfe8cc0b4dd3803ca70f4e9d2df2
Right
0,0,0,0
Text17
Desc.
Black
Expression
Center
Transparent
19,0,2,0.6
Tahoma,8.25,Bold,Point,False,0
e74f4d5f68174e738bd1566bde892605
Right
0,0,0,0
Text22
Base Cálc.
Black
Expression
Center
Transparent
22.4,0,1.6,0.6
Tahoma,8.25,Bold,Point,False,0
67d9ba5440b04b2e8d825566a57871b8
Right
0,0,0,0
Text23
ICMS
Black
Expression
Center
Transparent
3.8,0,0.8,0.6
Tahoma,8.25,Bold,Point,False,0
c83380825e744a989b99d4bb4cd955a8
0,0,0,0
Text52
Série
Black
Expression
Center
Transparent
4.6,0,1.2,0.6
Tahoma,8.25,Bold,Point,False,0
5862d8d23c104a82a432c308e84734a6
Right
0,0,0,0
Text54
Modelo
Black
Expression
Center
Transparent
24,0,2,0.6
Tahoma,8.25,Bold,Point,False,0
8a30b5654a6c4c56a56803dfdf348622
Right
0,0,0,0
Text58
ISENTA
Black
Expression
Center
Transparent
26,0,1.6,0.6
Tahoma,8.25,Bold,Point,False,0
257903dafcd34c89b31c2b0f994f2463
Right
0,0,0,0
Text61
OUTRAS
Black
Expression
Center
Transparent
21,0,1.4,0.6
Tahoma,8.25,Bold,Point,False,0
4e110e30667e4a44a94a5aa06752db60
Right
0,0,0,0
Text25
Alíquota
Black
Expression
Center
Transparent
11.8,0,2,0.6
Tahoma,8.25,Bold,Point,False,0
1f7e665013ad4d1083953f44dd1e5808
Right
0,0,0,0
Text26
Valor
Black
Expression
Center
Transparent
13.8,0,1.8,0.6
Tahoma,8.25,Bold,Point,False,0
cba20ea2dfae4dbaa90341bbea40140d
Right
0,0,0,0
Text33
Acresc.
Black
Expression
Center
Transparent
17.2,0,1.8,0.6
Tahoma,8.25,Bold,Point,False,0
2f7aed1f69ba4881818f42c4575ae353
Right
0,0,0,0
Text24
Deson.
Black
Expression
Center
{dados.numero}
GroupHeaderBand1
None
Transparent
0,6.4,27.7,0.4
Transparent
0,0,1.8,0.4
Tahoma,8.25,Regular,Point,False,0
823f0e539bf34e6e9cb7e81069b3fee9
0,0,0,0
Text7
{dados.data_ent_sai}
Black
Expression
Center
Transparent
1.8,0,2,0.4
Tahoma,8.25,Regular,Point,False,0
db8253923816400da5eb4ac8cd73fb4b
0,0,0,0
Text8
{dados.numero}
Black
Expression
Center
Transparent
5.8,0,3.8,0.4
Tahoma,8.25,Regular,Point,False,0
e9317893e27840ea9b99275038026714
0,0,0,0
Text11
{dados.destinatario_nome}
Black
DataColumn
Center
Transparent
9.6,0,1.2,0.4
Tahoma,8.25,Regular,Point,False,0
679beaa6363541f9a86e69a935c77866
Right
0,0,0,0
Text12
{dados.cfop}
Black
DataColumn
Center
Transparent
10.8,0,1,0.4
Tahoma,8.25,Regular,Point,False,0
c26ed60e6ff94888a322e49740d3a9ad
Right
0,0,0,0
Text28
{dados.destinatario_uf}
Black
DataColumn
Center
Transparent
15.6,0,1.6,0.4
Tahoma,8.25,Regular,Point,False,0
00b731607dca480d88a3d1b0d8066af2
Right
0,0,0,0
Text29
{dados.desconto}
Black
,
.
1
DataColumn
Center
Transparent
19,0,2,0.4
Tahoma,8.25,Regular,Point,False,0
ad401051c3d34b80a1a294701dec620e
Right
0,0,0,0
Text30
{dados.base_icms}
Black
,
.
1
Expression
Center
Transparent
22.4,0,1.6,0.4
Tahoma,8.25,Regular,Point,False,0
ebb41a953aa64ff1b8fc6ac46d1a9c2e
Right
0,0,0,0
Text31
{dados.valor_icms}
Black
,
.
1
Expression
Center
Transparent
3.8,0,0.8,0.4
Tahoma,8.25,Regular,Point,False,0
0ce6d918b7b74da8aa1772b47749a922
0,0,0,0
Text53
{dados.serie_nfe}
Black
DataColumn
Center
Transparent
4.6,0,1.2,0.4
Tahoma,8.25,Regular,Point,False,0
5c4de7439f5042b1901855ddca7441ec
0,0,0,0
Text55
{dados.modelo}
Black
DataColumn
Center
Transparent
21,0,1.4,0.4
Tahoma,8.25,Regular,Point,False,0
06d4f2a260644c73a8424076dd87df11
Right
0,0,0,0
Text57
{dados.aliquota_icms}
Black
,
.
1
Expression
Center
Transparent
24,0,2,0.4
Tahoma,8.25,Regular,Point,False,0
1b390f3a3a6b451fa5f47ec747117111
Right
0,0,0,0
Text59
{dados.ISENTAS}
Black
,
.
1
DataColumn
Center
Transparent
26,0,1.6,0.4
Tahoma,8.25,Regular,Point,False,0
73eaf40f7b4049599e945c998b60a7c4
Right
0,0,0,0
Text60
{dados.OUTRAS}
Black
,
.
1
Expression
Center
Transparent
11.8,0,2,0.4
Tahoma,8.25,Regular,Point,False,0
fec155023a9e40438bd95bcd5a133089
Right
0,0,0,0
Text27
{dados.valor_tot}
Black
,
.
1
DataColumn
Center
Transparent
13.8,0,1.8,0.4
Tahoma,8.25,Regular,Point,False,0
177d98f07dbf49f2bd9ea97ad0268e21
Right
0,0,0,0
Text34
{dados.rateio_despesas+dados.rateio_icms+dados.rateio_frete+dados.rateio_seguro+dados.rateio_ipi}
Black
,
.
1
Expression
Center
Transparent
17.2,0,1.8,0.4
Tahoma,8.25,Regular,Point,False,0
3a25ec16a4e64e589707ac5dbd3c8aee
Right
0,0,0,0
Text32
{dados.rateio_desonerado}
Black
,
.
1
DataColumn
Center
0,0.4,27.6,0.0254
Black
Black
HorizontalLinePrimitive1
Black
dados
DataBand1
ASC
destinatario_nome
ASC
numero
Transparent
0,7.6,27.7,0.8
Transparent
9.8,0.2,2,0.4
Tahoma,8.25,Bold,Point,False,0
fe836a0d4c6740aeb70ff8b11921ea01
Right
0,0,0,0
Text13
Totais:
Black
Expression
Center
Transparent
11.8,0.2,2,0.4
Tahoma,8.25,Regular,Point,False,0
2438af700ca54ceba36ba22d43f62be3
Right
0,0,0,0
Text15
{Sum(DataBand1,dados.valor_tot)}
Black
,
.
1
Totals
Center
Transparent
19,0.2,2,0.4
Tahoma,8.25,Regular,Point,False,0
21262bdbe7914d83ba964ce12b783585
Right
0,0,0,0
Text36
{Sum(DataBand1,dados.base_icms)}
Black
,
.
1
Totals
Center
Transparent
22.4,0.2,1.6,0.4
Tahoma,8.25,Regular,Point,False,0
3599974077dd45539aeafc61382ff739
Right
0,0,0,0
Text37
{Sum(DataBand1,dados.valor_icms)}
Black
,
.
1
Totals
Center
Transparent
24,0.2,2,0.4
Tahoma,8.25,Regular,Point,False,0
e621f383ddfb46ba85d4faa44ce95440
Right
0,0,0,0
Text62
{Sum(DataBand1,dados.ISENTAS)}
Black
,
.
1
Totals
Center
Transparent
26,0.2,1.6,0.4
Tahoma,8.25,Regular,Point,False,0
beb862e27eff44288abcabd0d8e2f050
Right
0,0,0,0
Text63
{Sum(DataBand1,dados.OUTRAS)}
Black
,
.
1
Expression
Center
Transparent
13.8,0.2,1.8,0.4
Tahoma,8.25,Regular,Point,False,0
88194468eedd45469ef91d4a7818ffb4
Right
0,0,0,0
Text35
{Sum(dados.rateio_despesas+dados.rateio_icms+dados.rateio_frete+dados.rateio_seguro+dados.rateio_ipi)}
Black
,
.
1
Expression
Center
Transparent
15.6,0.2,1.6,0.4
Tahoma,8.25,Regular,Point,False,0
64f99d9f036244aba8e0969dc79d22a6
Right
0,0,0,0
Text39
{Sum(dados.desconto)}
Black
,
.
1
Expression
Center
Transparent
17.2,0.2,1.8,0.4
Tahoma,8.25,Regular,Point,False,0
12c53d21d9b1483eadb616a021742104
Right
0,0,0,0
Text38
{Sum(DataBand1,dados.rateio_desonerado)}
Black
,
.
1
Totals
Center
GroupFooterBand1
Transparent
0,9.2,27.7,0.8
Transparent
8.8,0.2,3,0.4
Tahoma,8.25,Bold,Point,False,0
be319b991da34c4abaf3919ef6702ec9
Right
0,0,0,0
Text42
Total Geral:
Black
Expression
Center
Transparent
11.8,0.2,2,0.4
Tahoma,8
389b7d5c44f344ff91b319bdfc1bc504
Right
0,0,0,0
Text43
{Sum(DataBand1,dados.valor_tot)}
Black
,
.
1
Totals
Center
Transparent
19,0.2,2,0.4
Tahoma,8
2853cdbbcb70447f9efc27011f57deb4
Right
0,0,0,0
Text45
{Sum(DataBand1,dados.base_icms)}
Black
,
.
1
Totals
Center
Transparent
22.4,0.2,1.6,0.4
Tahoma,8
0e00723d73ad45878b5ec306e5c689e0
Right
0,0,0,0
Text46
{Sum(DataBand1,dados.valor_icms)}
Black
,
.
1
Totals
Center
Transparent
24,0.2,2,0.4
Tahoma,8
ac52a1b8c57d48d89e0c058ee345df96
Right
0,0,0,0
Text64
{Sum(dados.ISENTAS)}
Black
,
.
1
Expression
Center
Transparent
26,0.2,1.6,0.4
Tahoma,8
2c055a0056a74d41bb6bfc09911f7203
Right
0,0,0,0
Text65
{Sum(DataBand1,dados.OUTRAS)}
Black
,
.
1
Totals
Center
Transparent
13.8,0.2,1.8,0.4
Tahoma,8
72b0cf840d0c4c528ba7ab17382e263f
Right
0,0,0,0
Text40
{Sum(dados.rateio_despesas+dados.rateio_icms+dados.rateio_frete+dados.rateio_seguro+dados.rateio_ipi)}
Black
,
.
1
Expression
Center
Transparent
15.6,0.2,1.6,0.4
Tahoma,8.25,Regular,Point,False,0
3590c32d2e8742488b924be0d1b7359b
Right
0,0,0,0
Text41
{Sum(dados.desconto)}
Black
,
.
1
Expression
Center
Transparent
17.2,0.2,1.8,0.4
Tahoma,8
ff42f8f4d099483fb12ae8278762f203
Right
0,0,0,0
Text47
{Sum(DataBand1,dados.rateio_desonerado)}
Black
,
.
1
Totals
Center
ReportSummaryBand1
16e140f4ea7b4950b32fdf7a12ea7df3
1,1,1,1
Page1
Landscape
21
29.7
Arial,100
[50:0:0:0]
Control
Window
32,56,96,20
Microsoft Sans Serif,8
Black
Short
a7c7a4bcc2eb4955ab6cde4a0ba5af86
32, 56
12/31/9998 12:00:00 AM
1/1/1753 12:00:00 AM
dtInicial
96, 20
2/6/2018 4:30:02 PM
Window
168,56,96,20
Microsoft Sans Serif,8
Black
Short
2087dd10db564b3dabe2b8659e1572a1
168, 56
12/31/9998 12:00:00 AM
1/1/1753 12:00:00 AM
dtFinal
96, 20
2/6/2018 4:30:08 PM
Control
32,32,96,24
Microsoft Sans Serif,8
Black
111fc3783c724ebcbcf857beb5908fba
32, 32
LabelControl1
96, 24
Data Inicial
Control
168,32,96,24
Microsoft Sans Serif,8
Black
de88df2b281a471aa8f07ab4a1b5c075
168, 32
LabelControl2
96, 24
Data Final
32,104,96,24
Cancel
Microsoft Sans Serif,8
Black
6c3cf1854d00406fad372515b17e3607
32, 104
btnCancelar
96, 24
Cancelar
Data.From = dtInicial.Value;
Data.To = dtFinal.Value;
168,104,96,24
OK
Microsoft Sans Serif,8
Black
97f51dccb0ac45afaa711d0ba0f9c951
168, 104
btnGerar
96, 24
Gerar
Microsoft Sans Serif,8
5d4d0cf488d64308b56087b76ba501c7
0, 0
periodo
304, 192
Informe o período
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Report
2/17/2019 5:15:41 PM
9/25/2015 9:37:43 PM
1520e21bb1404f4fbca1df485c2b8c1b
Report
Centimeters
2015.1.0
CSharp